In [2]:
import pandas as pd
import numpy as np
import folium
import seaborn
import matplotlib.pyplot as plt
import os 
In [3]:
df=pd.read_csv("C:\\Users\\neeli\\Downloads\\Dataset .csv")
df.head()
Out[3]:
Restaurant ID Restaurant Name Country Code City Address Locality Locality Verbose Longitude Latitude Cuisines ... Currency Has Table booking Has Online delivery Is delivering now Switch to order menu Price range Aggregate rating Rating color Rating text Votes
0 6317637 Le Petit Souffle 162 Makati City Third Floor, Century City Mall, Kalayaan Avenu... Century City Mall, Poblacion, Makati City Century City Mall, Poblacion, Makati City, Mak... 121.027535 14.565443 French, Japanese, Desserts ... Botswana Pula(P) Yes No No No 3 4.8 Dark Green Excellent 314
1 6304287 Izakaya Kikufuji 162 Makati City Little Tokyo, 2277 Chino Roces Avenue, Legaspi... Little Tokyo, Legaspi Village, Makati City Little Tokyo, Legaspi Village, Makati City, Ma... 121.014101 14.553708 Japanese ... Botswana Pula(P) Yes No No No 3 4.5 Dark Green Excellent 591
2 6300002 Heat - Edsa Shangri-La 162 Mandaluyong City Edsa Shangri-La, 1 Garden Way, Ortigas, Mandal... Edsa Shangri-La, Ortigas, Mandaluyong City Edsa Shangri-La, Ortigas, Mandaluyong City, Ma... 121.056831 14.581404 Seafood, Asian, Filipino, Indian ... Botswana Pula(P) Yes No No No 4 4.4 Green Very Good 270
3 6318506 Ooma 162 Mandaluyong City Third Floor, Mega Fashion Hall, SM Megamall, O... SM Megamall, Ortigas, Mandaluyong City SM Megamall, Ortigas, Mandaluyong City, Mandal... 121.056475 14.585318 Japanese, Sushi ... Botswana Pula(P) No No No No 4 4.9 Dark Green Excellent 365
4 6314302 Sambo Kojin 162 Mandaluyong City Third Floor, Mega Atrium, SM Megamall, Ortigas... SM Megamall, Ortigas, Mandaluyong City SM Megamall, Ortigas, Mandaluyong City, Mandal... 121.057508 14.584450 Japanese, Korean ... Botswana Pula(P) Yes No No No 4 4.8 Dark Green Excellent 229

5 rows × 21 columns

In [4]:
df.columns
Out[4]:
Index(['Restaurant ID', 'Restaurant Name', 'Country Code', 'City', 'Address',
       'Locality', 'Locality Verbose', 'Longitude', 'Latitude', 'Cuisines',
       'Average Cost for two', 'Currency', 'Has Table booking',
       'Has Online delivery', 'Is delivering now', 'Switch to order menu',
       'Price range', 'Aggregate rating', 'Rating color', 'Rating text',
       'Votes'],
      dtype='object')
In [5]:
#level-2
#task-1
#ratings resturants
#Analyze the distribution of aggregate ratings and determine the most common rating range
In [6]:
ratings_column = df['Aggregate rating']
plt.figure(figsize=(8, 6))
plt.hist(ratings_column, bins=20, color='skyblue', edgecolor='black')
plt.xlabel('Aggregate Rating')
plt.ylabel('Frequency')
plt.title('Distribution of Aggregate Ratings')
plt.grid(axis='y')
plt.show()
most_common_bin = ratings_column.mode().values[0]
print(f"Most common rating range: {most_common_bin:.2f}")
No description has been provided for this image
Most common rating range: 0.00
In [7]:
#Calculate the average number of votes received by restaurants.
In [8]:
votes_column = df['Votes']
average_votes = votes_column.mean()
print(f"Average number of votes received by restaurants: {average_votes:.2f}")
Average number of votes received by restaurants: 156.91
In [9]:
#level-2
#task-2
#Cusinies combinations
#Identify the most common combinations of cuisines in the dataset.
In [10]:
cuisines_column = df['Cuisines']
cuisines_column = cuisines_column.astype(str)
all_cuisines = [cuisine.strip() for cuisines in cuisines_column for cuisine in cuisines.split(',') if isinstance(cuisines, str)]
cuisine_series = pd.Series(all_cuisines)
cuisine_counts = cuisine_series.value_counts()
print("Top 10 most common cuisine combinations:")
print(cuisine_counts.nlargest(10))
Top 10 most common cuisine combinations:
North Indian    3960
Chinese         2735
Fast Food       1986
Mughlai          995
Italian          764
Bakery           745
Continental      736
Cafe             703
Desserts         653
South Indian     636
Name: count, dtype: int64
In [11]:
#level-2
#task-3
#Geographic Analysis
#Plot the locations of restaurants on a map using longitude and latitude coordinates.columns = df.columns.str.strip().str.lower()
In [18]:
df.columns = df.columns.str.strip().str.lower()


df = df.dropna(subset=['latitude', 'longitude'])


center_lat = df['latitude'].mean()
center_long = df['longitude'].mean()
restaurant_map = folium.Map(location=[center_lat, center_long], zoom_start=12)


for idx, row in df.iterrows():
    folium.Marker(
        location=[row['latitude'], row['longitude']],
        popup=row['restaurant name'],
        tooltip=row['restaurant name']
    ).add_to(restaurant_map)
restaurant_map.save('restaurant_map.html')


restaurant_map
Out[18]:
Make this Notebook Trusted to load map: File -> Trust Notebook
In [130]:
#Identify any patterns or clusters of restaurants in specific areas.
In [13]:
chain_counts = df["Restaurant Name"].value_counts()
restaurant_chains = chain_counts[chain_counts > 1]

print("Restaurant Chains:")
for chain_name, count in restaurant_chains.items():
    print(f"{chain_name}: {count} locations")
Restaurant Chains:
Cafe Coffee Day: 83 locations
Domino's Pizza: 79 locations
Subway: 63 locations
Green Chick Chop: 51 locations
McDonald's: 48 locations
Keventers: 34 locations
Pizza Hut: 30 locations
Giani: 29 locations
Baskin Robbins: 28 locations
Barbeque Nation: 26 locations
Giani's: 22 locations
Barista: 22 locations
Dunkin' Donuts: 22 locations
Costa Coffee: 20 locations
Pind Balluchi: 20 locations
Wah Ji Wah: 19 locations
Twenty Four Seven: 19 locations
Pizza Hut Delivery: 19 locations
Sagar Ratna: 19 locations
Republic of Chicken: 18 locations
KFC: 18 locations
Starbucks: 18 locations
Chaayos: 18 locations
Burger King: 16 locations
Haldiram's: 16 locations
Shree Rathnam: 15 locations
Frontier: 14 locations
Moti Mahal Delux: 14 locations
Bikanervala: 14 locations
Aggarwal Sweets: 14 locations
Behrouz Biryani: 13 locations
Karim's: 13 locations
Bikaner Sweets: 13 locations
Chicago Pizza: 12 locations
Apni Rasoi: 12 locations
34, Chowringhee Lane: 12 locations
Wow! Momo: 11 locations
Madras Cafe: 11 locations
Burger Point: 11 locations
Gopala: 10 locations
Shama Chicken Corner: 9 locations
Berco's: 9 locations
Nirula's Ice Cream: 9 locations
Sardar A Pure Meat Shop: 9 locations
Yo! China: 9 locations
Cocoberry: 9 locations
Punjabi Tadka: 8 locations
Angels in my Kitchen: 8 locations
Faasos: 8 locations
Ovenstory Pizza: 8 locations
Chowringhee: 8 locations
Punjabi Chaap Corner: 8 locations
Kebab Xpress: 8 locations
Nazeer Foods: 7 locations
RollsKing: 7 locations
Tpot: 7 locations
Mocha: 7 locations
Dolce Gelato: 7 locations
Tibb's Frankie: 7 locations
The Yellow Chilli: 7 locations
Slice of Italy: 7 locations
BTW: 7 locations
Khan Chacha: 7 locations
Chawla's?_: 7 locations
China Town: 7 locations
Chinese Hut: 7 locations
Sanjha Chulha: 6 locations
Moti Mahal Delux Tandoori Trail: 6 locations
Mr. Sub: 6 locations
Al Bake: 6 locations
Bikaner Sweets & Restaurant: 6 locations
TGI Friday's: 6 locations
Kings Kulfi: 6 locations
Pudding & Pie: 6 locations
Cafe Coffee Day - The Lounge: 6 locations
Southy: 6 locations
The Diet Kitchen: 6 locations
Biryani Blues: 6 locations
Goli Vada Pav No. 1: 6 locations
Punjabi Rasoi: 6 locations
The Beer Cafe: 6 locations
Wrapss: 6 locations
Mainland China: 6 locations
Farzi Cafe: 6 locations
Red Chilli: 5 locations
Nathu's Sweets: 5 locations
Instapizza: 5 locations
Chili's: 5 locations
Nando's: 5 locations
Aggarwal Sweet India: 5 locations
Texas Roadhouse: 5 locations
Cake Point: 5 locations
Pita Pit: 5 locations
Chinese Corner: 5 locations
The Midnight Heroes: 5 locations
Kake Da Hotel: 5 locations
L'Opera: 5 locations
Nukkadwala: 5 locations
Flirty Momo's: 5 locations
Viva Hyderabad: 5 locations
Swagath: 5 locations
Sandoz: 5 locations
Punjab Grill: 5 locations
Kettle & Kegs: 5 locations
The Chinese Hut: 5 locations
Captain Grub: 5 locations
Mad Over Donuts: 5 locations
Aggarwal Sweet Corner: 5 locations
SGF - Spice Grill Flame: 5 locations
Shree Bikaner Misthan Bhandar: 5 locations
Da Pizza Corner: 5 locations
Happy Hakka: 5 locations
Hot Pot: 4 locations
Chai Garam: 4 locations
Gola Sizzlers: 4 locations
Pakwan: 4 locations
Applebee's: 4 locations
Kathi Junction: 4 locations
Qureshi's Kabab Corner: 4 locations
Meatwale.com: 4 locations
Jamie's Italian: 4 locations
GoGourmet: 4 locations
The Coffee Bean & Tea Leaf: 4 locations
Sugar & Spice - Le Marche: 4 locations
The Kathis: 4 locations
Public Cafe: 4 locations
Kwality Wall's Swirl's: 4 locations
Chaska: 4 locations
Bun Intended: 4 locations
Pirates of Grill: 4 locations
South Indian Hut: 4 locations
DCK- Dana Choga's Kitchen: 4 locations
Gelato Vinto: 4 locations
Jungle Jamboree: 4 locations
Bawarchi: 4 locations
Deez Biryani & Kebabs: 4 locations
Chai Point: 4 locations
Hong Kong Express: 4 locations
Nirula's: 4 locations
Aapki Rasoi: 4 locations
Burger Xpress: 4 locations
Rainbows: 4 locations
Mx Corn: 4 locations
Colonel's Kababz: 4 locations
Punjabi Zaika: 4 locations
FreshMenu: 4 locations
Chawla's 2: 4 locations
Open Oven: 4 locations
Tea Villa Cafe: 4 locations
Puri Bakers: 4 locations
Nizam's Kathi Kabab: 4 locations
Zaika: 4 locations
AB's - Absolute Barbecues: 4 locations
Nite Bites: 4 locations
Punjabi's Veg Grill: 4 locations
Momo-Cha: 4 locations
Super Cake Shop: 4 locations
Big Chill: 4 locations
Movenpick: 3 locations
Mamagoto: 3 locations
Kanwarji's: 3 locations
Big Yellow Door: 3 locations
Foodies: 3 locations
Doughlicious: 3 locations
Zizo: 3 locations
Onesta: 3 locations
Chimney: 3 locations
Aggarwal Bikaner Sweets: 3 locations
Zaffran: 3 locations
Foodhall: 3 locations
Just Vada Pav: 3 locations
Roll Club: 3 locations
Amici Cafe: 3 locations
Chinese Food Corner: 3 locations
Kerala Cafe: 3 locations
Wok On Fire: 3 locations
Bats On Delivery: 3 locations
Amul Ice-Cream Parlour: 3 locations
Cafe Delhi Heights: 3 locations
Bharat Sweets: 3 locations
Chawla's Chic Inn: 3 locations
Tikka Town: 3 locations
Talaga Sampireun: 3 locations
Bikkgane Biryani: 3 locations
Shawarma Wala: 3 locations
True Blue: 3 locations
Punjabi Dhaba: 3 locations
Food Plaza: 3 locations
Chinese Food: 3 locations
SodaBottleOpenerWala: 3 locations
Breaktym: 3 locations
Defence Bakery: 3 locations
Muradabadi Shahi Biryani & Chicken Corner: 3 locations
Tikka Junction: 3 locations
Aggarwal Sweets India: 3 locations
Not Just Paranthas: 3 locations
Krispy Kreme: 3 locations
HuHot Mongolian Grill: 3 locations
Hard Rock Cafe: 3 locations
Goosebumps: 3 locations
Street Foods by Punjab Grill: 3 locations
Habibi Express: 3 locations
Joost Juice Bar: 3 locations
Desi Vibes: 3 locations
La Pino'z Pizza: 3 locations
The Chai Story: 3 locations
Wah G Wah: 3 locations
Hira Sweets: 3 locations
Hasty Tasty: 3 locations
Shahenshah: 3 locations
Midnight Hunger Hub: 3 locations
Riyaz Biryani Corner: 3 locations
Polka Pastry & Snack Bar: 3 locations
Changezi Chicken: 3 locations
Aggarwal Sweet Centre: 3 locations
Urban Punjab: 3 locations
Side Wok: 3 locations
Havmor Ice Cream: 3 locations
The Fisherman's Wharf: 3 locations
Cafe Turtle: 3 locations
Chaophraya: 3 locations
Sri Balaji: 3 locations
Chawla's Tandoori Junction: 3 locations
Palmshore: 3 locations
Rollmaal: 3 locations
Speedy Chow: 3 locations
Om Sweets & Snacks: 3 locations
Taco Bell: 3 locations
Food Scouts: 3 locations
New Madras Cafe: 3 locations
Cakes & Bakes: 3 locations
Sushiya Express: 3 locations
KB's Kulfi & Icecream: 3 locations
Bunty Dhaba: 3 locations
Flying Cakes: 3 locations
Baked Buns: 3 locations
Mitra Da Dhaba: 3 locations
Mr. Brown: 3 locations
Veg Ex: 3 locations
BarShala: 3 locations
Tea Halt: 3 locations
221 B Baker Street: 3 locations
The Golden Dragon: 3 locations
Burger Singh: 3 locations
Finger Licious: 3 locations
Pizza Hub: 3 locations
The Chaiwalas: 3 locations
Jaiveer Naan & Chaap: 3 locations
Punjab Restaurant: 3 locations
Captain Bill$ Deliverz: 3 locations
Health Buzzz: 3 locations
Little Chef: 3 locations
Punjabi Pakwaan: 3 locations
Biryani By Kilo: 3 locations
QD's Restaurant: 3 locations
Hangchuaa's Chinese Food Corner: 3 locations
Indian Coffee House: 3 locations
Dilli Darbar: 3 locations
Niti Shake & Ice Cream Hub: 3 locations
Saravana Bhavan: 3 locations
Bake N Shake: 3 locations
Gazebo: 3 locations
Pizza Station: 3 locations
D?_ner Grill: 3 locations
Naivedyam: 3 locations
Radha Swami Shudh Vaishno Dhaba: 3 locations
Druk: 2 locations
Qureshi Kabab Corner: 2 locations
Da Pizza Zone: 2 locations
The Cheesecake Factory: 2 locations
Raj Restaurant: 2 locations
The Night Owl: 2 locations
Bikaner's: 2 locations
Papa Veg Chinese Food: 2 locations
Khan Chicken Biryani: 2 locations
Bikaner Sweets & Bakers: 2 locations
Metro Dhaba: 2 locations
Naturals Ice Cream: 2 locations
Zaika Kathi Rolls: 2 locations
Flavours: 2 locations
Spanish Delights: 2 locations
Hunger's Hub: 2 locations
Relax Xpress: 2 locations
The Barbeque Company: 2 locations
Dosa Plaza: 2 locations
Whipped: 2 locations
Night Munchers: 2 locations
Khalsa Veg Corner: 2 locations
Mr. Momo: 2 locations
Hot Cherries: 2 locations
Wild Chef House: 2 locations
MR.D - Deliciousness Delivered: 2 locations
Royal Spice: 2 locations
The Great Kabab Factory: 2 locations
Ceviche Tapas Bar & Restaurant: 2 locations
Fresh Meat CO: 2 locations
Brown Town: 2 locations
Moksha: 2 locations
Big Biryani: 2 locations
Bon Bon Pastry Shop: 2 locations
Mother's Kitchen: 2 locations
Golden Bakery: 2 locations
Mom's Kitchen: 2 locations
New Punjabi Khana: 2 locations
Oh Buoy: 2 locations
Americana Kitchen and Bar: 2 locations
Carl's Jr.: 2 locations
Hungry - I: 2 locations
Al Zaika: 2 locations
SpiceKlub: 2 locations
Delhi Club House: 2 locations
Pebble Street: 2 locations
Biryani Express: 2 locations
Kati Roll Cottage: 2 locations
Stop My Starvation: 2 locations
Midnight Hunger: 2 locations
Kulcha King: 2 locations
Beijing Street: 2 locations
Nazeer Delicacies: 2 locations
Singz: 2 locations
Pho King Awesome: 2 locations
Anupam Sweets: 2 locations
Baba Chicken Ludhiana Wale: 2 locations
AB's Absolute Barbecues: 2 locations
Rolling Beans: 2 locations
The Culinary Pitaara: 2 locations
Garam Dharam: 2 locations
Chinese Fast Food: 2 locations
The China Town: 2 locations
Aggarwal Sweets Centre: 2 locations
Embassy: 2 locations
New Kadimi: 2 locations
Caffe Tonino: 2 locations
Pandit Ji Ki Apni Rasoi: 2 locations
Shree Durga Dosa: 2 locations
Sagar Dhaba: 2 locations
Angeethi: 2 locations
Basil Tree: 2 locations
China Hot Pot: 2 locations
Punjabee's Darbar: 2 locations
Khana Khazana: 2 locations
Natural Ice Cream: 2 locations
Jyoti Sweets: 2 locations
New Town Cafe - Park Plaza: 2 locations
Biryani Vice: 2 locations
Riyaz Chicken Corner: 2 locations
Oberoi's: 2 locations
Jahangeer Foods: 2 locations
Green Restaurant: 2 locations
Momos House: 2 locations
Miam: 2 locations
Delight Express: 2 locations
China Hut: 2 locations
Hawkers: 2 locations
Crazy Noodles: 2 locations
South Cafe: 2 locations
Zaaika Junction: 2 locations
Le Chef: 2 locations
WTF - World's Tastiest Food: 2 locations
Biryani Art: 2 locations
Moon Bite: 2 locations
Gupta Chat Corner: 2 locations
Pizza King: 2 locations
Pastry Palace: 2 locations
Tipu Sultan: 2 locations
All About Food: 2 locations
Snack Shack: 2 locations
Cafe Brown Sugar: 2 locations
The Pirates Of China Town: 2 locations
Arabian Delites: 2 locations
Kake Di Hatti: 2 locations
Burgrill: 2 locations
Chilli Tadka: 2 locations
Ashoka Restaurant: 2 locations
Cafe Coffee Day The Square: 2 locations
Delhi Chaat Bhandar: 2 locations
Ashok Meat Wala: 2 locations
Juice Lounge: 2 locations
Shamji Sweets: 2 locations
Fluffles - The Fluffy Waffle Co.: 2 locations
Ram Chinese Food: 2 locations
Chawnsan Chef: 2 locations
Reena Restaurant: 2 locations
Invitation: 2 locations
Soya Bite's: 2 locations
Choco Kraft: 2 locations
Bakingo: 2 locations
Gulab: 2 locations
Garam Masala: 2 locations
Anand Sweets: 2 locations
Singh Chicken: 2 locations
Baker's Stop: 2 locations
Raj Rasoi: 2 locations
Grover Sweets: 2 locations
Dev Food: 2 locations
Konetto Pizza: 2 locations
Dunkin Donuts: 2 locations
Perfect Bake: 2 locations
Blue Tokai Coffee Roasters: 2 locations
34 Parkstreet Lane: 2 locations
Pandey Chinese Hut: 2 locations
Rajdhani Restaurant: 2 locations
Maggi Point: 2 locations
The Taste: 2 locations
Flavours Kitchen: 2 locations
Suruchi: 2 locations
The Chocolate Room: 2 locations
Aap Ki Khatir: 2 locations
Roti Aur Boti: 2 locations
Imperfecto: 2 locations
Firangi Bake: 2 locations
Out Of The Box: 2 locations
Hungry Minister: 2 locations
Biryani Bot: 2 locations
Black Pepper: 2 locations
Hurry's Paratha: 2 locations
Yomo-Your Only Momo Outlet: 2 locations
Jain Restaurant: 2 locations
Dilli Light: 2 locations
Burger Joint: 2 locations
Hot Stuff: 2 locations
Paradise: 2 locations
Dilli BC: 2 locations
Sumo Sushi: 2 locations
Bakers Oven: 2 locations
Punjabi By Nature: 2 locations
Mogambo Kitchen: 2 locations
Sbarro: 2 locations
Paramjeet Machi Wala: 2 locations
Kake Da Dhaba: 2 locations
La Americana: 2 locations
Mithaas: 2 locations
Biryaniwala: 2 locations
Kesarwa Bakez: 2 locations
Nutritious Nation: 2 locations
Bake Walkers: 2 locations
Green Valley Chinese Food: 2 locations
Chinese Hot: 2 locations
Mithaas Sweets: 2 locations
The Cake Shop: 2 locations
China Garden: 2 locations
Kumar Pastry Shop: 2 locations
Twisted Tacos: 2 locations
Hwealthcafe: 2 locations
Whatslife.in: 2 locations
Chutneez Restaurant Lounge & Bar: 2 locations
Kamal's: 2 locations
Shake Square: 2 locations
Pasta Hub: 2 locations
Chawla's Tandoori Xpress: 2 locations
Caffe 9: 2 locations
The Roll Van: 2 locations
Truffles: 2 locations
Lasha Chinese Food: 2 locations
Baker Street: 2 locations
Hot & Spicy: 2 locations
Koyla Kebab: 2 locations
Adyar Ananda Bhavan: 2 locations
10 Downing Street: 2 locations
Matchbox: 2 locations
Tamura: 2 locations
Smoke House Deli: 2 locations
Fit Bites: 2 locations
Manohar Dairy And Restaurant: 2 locations
Bombay Brasserie: 2 locations
Flavors Of London: 2 locations
Frozen Factory: 2 locations
Bhappe Di Hatti: 2 locations
Desi Tadka: 2 locations
Kanha Sweets: 2 locations
Teddy Boy: 2 locations
KC Bakers: 2 locations
Nawabi Mughlai Zaika: 2 locations
The Flying Saucer Cafe: 2 locations
Mysore Cafe: 2 locations
The Tandoor: 2 locations
The Junkyard Cafe: 2 locations
Bikaner Misthan Bhandar: 2 locations
Gupta Ji Ka Dhaba: 2 locations
Gung The Palace: 2 locations
Bhoj Restaurant: 2 locations
The Kitchen: 2 locations
Dezertfox: 2 locations
4700BC Popcorn: 2 locations
Underdoggs Sports Bar & Grill: 2 locations
San Carlo: 2 locations
Bikano Chat Cafe: 2 locations
Bengal Sweet Corner: 2 locations
Amritsari Dhaba: 2 locations
Metro Fast Food: 2 locations
Shawarma King's: 2 locations
Nagpal's: 2 locations
Pizza Day: 2 locations
Shankar Fast Food: 2 locations
Chinese King: 2 locations
Chao Cart: 2 locations
The Mirch Masala: 2 locations
Anjlika Pastry Shop: 2 locations
Wai Yu Mun Ching: 2 locations
Chili's Grill & Bar: 2 locations
6 Pack Momos: 2 locations
Spooky Sky: 2 locations
Night Food Xprs: 2 locations
BonJuz: 2 locations
Weird Time Food: 2 locations
Twigly: 2 locations
The Artful Baker: 2 locations
Amar Bakery: 2 locations
Perch Wine & Coffee Bar: 2 locations
Liquid: 2 locations
Dishoom: 2 locations
Granite City Food & Brewery: 2 locations
Taste of India: 2 locations
Magic Masala: 2 locations
Gymkhana: 2 locations
High On Burgers: 2 locations
Harry's Bar + Cafe: 2 locations
The Blue Tandoor: 2 locations
Eggers Madhouse: 2 locations
D Food: 2 locations
Asian Haus: 2 locations
Sonya Bakery Cafe: 2 locations
Bikaner Kesarvala: 2 locations
Sibang Bakery: 2 locations
Bhimsain's Bengali Sweet House: 2 locations
Made In Punjab: 2 locations
Bijoli Grill: 2 locations
Chai Thela: 2 locations
Balaji Dhaba: 2 locations
Aggarwal Sweets & Restaurant: 2 locations
Wendy's: 2 locations
Madras Dosa & Chinese: 2 locations
Sethi's The Cake Shop: 2 locations
Mitthu Tikki Wala: 2 locations
Paapi Paet: 2 locations
Manohar Bikkaneri: 2 locations
Smaaash: 2 locations
A Piece of Paris: 2 locations
Cones & Curries: 2 locations
Urban Dhaba: 2 locations
Mahi Rasoi: 2 locations
Munch Nation: 2 locations
Sadda Adda: 2 locations
The Chatter House: 2 locations
Crudo Juicery: 2 locations
VadaPav 'n' Frankie: 2 locations
The Breakfast Club: 2 locations
Oberoi Biryani: 2 locations
Wheelyz: 2 locations
Yadav Sweets: 2 locations
Los Agaves: 2 locations
Drool Waffles: 2 locations
Hornbill: 2 locations
The Cafe: 2 locations
Wagh Bakri Tea Lounge: 2 locations
Chalte Firte Momos & Special Foods: 2 locations
Ammu's South Indian Restaurant: 2 locations
Nooba: 2 locations
Fish Streat: 2 locations
The Big Chill Cakery: 2 locations
Pizza Diet: 2 locations
Madras Coffee House: 2 locations
Garota de Ipanema: 2 locations
Barbeque Ville: 2 locations
Little Italy: 2 locations
Kebab Gali: 2 locations
Murliwala Bakers: 2 locations
Litti.In: 2 locations
Baking Bad: 2 locations
Tandoori Junction: 2 locations
First Eat: 2 locations
Cafe Buddy's: 2 locations
Coldpress Company: 2 locations
Say Cheese: 2 locations
ZASTY: 2 locations
Pizza Yum: 2 locations
JSB Evergreen Snack & Sweets: 2 locations
Fast Trax: 2 locations
Clever Fox Cafe: 2 locations
Joey's Pizza: 2 locations
Grillz: 2 locations
Coco Bambu: 2 locations
Timboo Cafe: 2 locations
Nanking: 2 locations
Habibi: 2 locations
Din Tai Fung: 2 locations
Cinnabon: 2 locations
Silantro Fil-Mex: 2 locations
EDC Mania: 2 locations
Drifters Cafe: 2 locations
Haldiram Bhujiawala: 2 locations
D?_vero??lu: 2 locations
The Mad Teapot/The Wishing Chair: 2 locations
Spice Route: 2 locations
The Bake Studio: 2 locations
Puja Sandwich House: 2 locations
OCD - Online Cake Delivery: 2 locations
Muffins: 2 locations
Rasoi - The Indian Zaika: 2 locations
Vadapav Junction: 2 locations
Super Snacks: 2 locations
Green Chilli: 2 locations
Roll Corner: 2 locations
Bobby Tikki Wala: 2 locations
Dabba Meat: 2 locations
Crust N Cakes: 2 locations
Chennai Express: 2 locations
Fresh n Refresh: 2 locations
Garden Hut: 2 locations
Mellow Mushroom: 2 locations
Rhinehart's Oyster Bar: 2 locations
Cake 24x7: 2 locations
Bake Club: 2 locations
Royale Bakers: 2 locations
South Indian Corner: 2 locations
Fabulous Cake Bites: 2 locations
Chaap Point: 2 locations
The National: 2 locations
Syall Kotian Da Dhaba: 2 locations
Rajshree: 2 locations
Go Kylin: 2 locations
Aggarwal's Sweets Paradise: 2 locations
Burger Hut: 2 locations
Lazeez Restaurant: 2 locations
Madhuvan Chinese Fast Food: 2 locations
Chick-fil-A: 2 locations
Cook Du Kdu: 2 locations
Theos: 2 locations
Ghar Ka Khana: 2 locations
Food Express: 2 locations
Mirchievous: 2 locations
Rasoi: 2 locations
Bikaner Rasoi: 2 locations
Alaturka: 2 locations
Kitchen King: 2 locations
Big Fat Sandwich: 2 locations
Red Mango: 2 locations
Food Factory: 2 locations
Hunger Strike: 2 locations
Kamboj's: 2 locations
Tandoori Tadka: 2 locations
Cake Palace: 2 locations
Hot Joint Fast Food: 2 locations
Hyderabad House: 2 locations
Ichiban: 2 locations
Aggarwal Bikaneri Sweets: 2 locations
Papa Buns: 2 locations
Adarsh Kulfi: 2 locations
Punjabi Chicken: 2 locations
Evergreen Sweets: 2 locations
bu??no: 2 locations
Ankur Family Restaurant: 2 locations
Effingut Brewerkz: 2 locations
Comesum: 2 locations
Aggarwal Sweet & Bakers: 2 locations
Brijwasi Restaurant: 2 locations
Street Cafe: 2 locations
Shyam Sweets: 2 locations
Chawla Family Restaurant: 2 locations
Country Curries: 2 locations
Faaso's: 2 locations
Green Leaf: 2 locations
The Crab Shack: 2 locations
Vaishno Punjabi Dhaba: 2 locations
Vaishno Rasoi: 2 locations
Dilli Rasoi: 2 locations
Cafe Diva: 2 locations
Ramesh Vaishno Dhaba: 2 locations
Yumm Biryani: 2 locations
Essen Foods: 2 locations
Chai Mantra: 2 locations
Pasta Hut: 2 locations
Senorita's: 2 locations
Caff?? La Poya: 2 locations
South Indian Cafe: 2 locations
Chawlas 2: 2 locations
Tea Trails: 2 locations
Laxmi Ice Cream: 2 locations
Organic Express: 2 locations
Yo! Dimsum: 2 locations
Jack Po!tato's: 2 locations
The Chef: 2 locations
Patiala Shahi: 2 locations
Sandwich King: 2 locations
Special Chicken Biryani: 2 locations
The Belgian Fries Company: 2 locations
Wood Box Cafe: 2 locations
Shalimar Vyanjan: 2 locations
Arabian Nites: 2 locations
Moti Mahal Delux- Legendary Culinary: 2 locations
The Square Meal: 2 locations
Night Food Delivery: 2 locations
Mr. Baker's: 2 locations
Aureo Dine & Bake House: 2 locations
Kaveri Restaurant And Caterers: 2 locations
U Like: 2 locations
New Zaika: 2 locations
Big Wong XL: 2 locations
Gullu's: 2 locations
Kolkata Kathi Roll: 2 locations
Italiano: 2 locations
Kolkata Hot Kathi Roll: 2 locations
Zooby's Kitchen: 2 locations
Hotel Malabar: 2 locations
Dana Pani: 2 locations
Big Dragon: 2 locations
Standard Sweets: 2 locations
Kolkata Biryani House: 2 locations
Circus: 2 locations
Pitstop: 2 locations
The Big Scoop: 2 locations
Imly: 2 locations
Prince Chaat Corner: 2 locations
Chawla's: 2 locations
Khidmat: 2 locations
The Creamery: 2 locations
Shri Ram Restaurant: 2 locations
Chauhan Hotel: 2 locations
Au Bon Pain: 2 locations
Let's Noodle: 2 locations
Fat Lulu's: 2 locations
Oh! Calcutta: 2 locations
Otik Cake Shop: 2 locations
Olive Bistro: 2 locations
Raasta: 2 locations
The Pint Room: 2 locations
Snacks Point: 2 locations
The Dosa King: 2 locations
Chokola: 2 locations
Town Hall: 2 locations
Halki Aanch: 2 locations
Snack Junction: 2 locations
Delhi Biryani Hut: 2 locations
Beliram Degchiwala: 2 locations
In [132]:
#level-2
#task-4
#resturant chains
#Identify if there are any restaurant chains present in the dataset
In [133]:
restaurant_counts = df['Restaurant Name'].value_counts()
chains = restaurant_counts[restaurant_counts > 1]
print(f"Number of potential restaurant chains: {len(chains)}")
print(chains)
Number of potential restaurant chains: 734
Restaurant Name
Cafe Coffee Day       83
Domino's Pizza        79
Subway                63
Green Chick Chop      51
McDonald's            48
                      ..
Town Hall              2
Halki Aanch            2
Snack Junction         2
Delhi Biryani Hut      2
Beliram Degchiwala     2
Name: count, Length: 734, dtype: int64
In [134]:
#Analyze the ratings and popularity of different restaurant chains 
In [135]:
chain_analysis = df.groupby('Restaurant Name').agg(
    Average_Rating=('Aggregate rating', 'mean'),
    Total_Votes=('Votes', 'sum'),
    Location_Count=('Restaurant ID', 'count')
).reset_index()
chain_analysis = chain_analysis[chain_analysis['Location_Count'] > 1]
top_chains_by_rating = chain_analysis.sort_values(by='Average_Rating', ascending=False)
top_chains_by_popularity = chain_analysis.sort_values(by='Total_Votes', ascending=False)
print("Top Restaurant Chains by Average Rating:")
print(top_chains_by_rating.head(10))
print("\nTop Restaurant Chains by Total Votes:")
print(top_chains_by_popularity.head(10))
Top Restaurant Chains by Average Rating:
                Restaurant Name  Average_Rating  Total_Votes  Location_Count
6263           Talaga Sampireun           4.900         5514               3
5850           Silantro Fil-Mex           4.850         1364               2
102     AB's Absolute Barbecues           4.850         3151               2
101   AB's - Absolute Barbecues           4.825        13400               4
4464         Naturals Ice Cream           4.800         3094               2
2806                   Gymkhana           4.700          328               2
6504     The Cheesecake Factory           4.650         3010               2
2076                    Dishoom           4.600         1269               2
2585          Garota de Ipanema           4.600           59               2
1510                    Chili's           4.580         8156               5

Top Restaurant Chains by Total Votes:
                Restaurant Name  Average_Rating  Total_Votes  Location_Count
663             Barbeque Nation        4.353846        28142              26
101   AB's - Absolute Barbecues        4.825000        13400               4
785                   Big Chill        4.475000        10853               4
2297                 Farzi Cafe        4.366667        10098               6
6988                   Truffles        3.950000         9682               2
1510                    Chili's        4.580000         8156               5
3261               Joey's Pizza        4.250000         7807               2
796             Big Yellow Door        4.266667         7511               3
5571            Saravana Bhavan        4.133333         7238               3
6080                  Starbucks        3.805556         7139              18
In [ ]:
#level-3
#task-1
#Task: Restaurant Reviews
#Identify if there are any restaurant chains present in the dataset
In [15]:
import pandas as pd
restaurant_counts =df['Restaurant Name'].value_counts()
restaurant_chains = restaurant_counts[restaurant_counts > 1]
print("Restaurant Chains:")
print(restaurant_chains)
Restaurant Chains:
Restaurant Name
Cafe Coffee Day       83
Domino's Pizza        79
Subway                63
Green Chick Chop      51
McDonald's            48
                      ..
Town Hall              2
Halki Aanch            2
Snack Junction         2
Delhi Biryani Hut      2
Beliram Degchiwala     2
Name: count, Length: 734, dtype: int64
In [ ]:
#Analyze the ratings and popularity of different restaurant chains
In [17]:
import pandas as pd
chain_summary = df.groupby('Restaurant Name').agg({
    'Aggregate rating': 'mean',
    'Votes': 'sum'
})
chain_summary.sort_values(by=['Aggregate rating', 'Votes'], ascending=[False, False], inplace=True)
print("Top Restaurant Chains:")
print(chain_summary.head(10))
Top Restaurant Chains:
                                            Aggregate rating  Votes
Restaurant Name                                                    
Talaga Sampireun                                         4.9   5514
Mirchi And Mime                                          4.9   3244
McGuire's Irish Pub & Brewery                            4.9   2238
Indian Accent - The Manor                                4.9   1934
Pom Pom's Teahouse and Sandwicheria                      4.9   1457
Mazzaro's Italian Market                                 4.9   1424
Mr. Dunderbak's Biergarten and Marketplatz               4.9   1413
Tresind - Nassima Royal Hotel                            4.9   1352
Mama's Fish House                                        4.9   1343
Yellow Dog Eats                                          4.9   1252
In [ ]: